USE [vudu]
GO
/****** Object:  StoredProcedure [dbo].[Archivar]    Script Date: 01/29/2012 13:54:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[ArchivarPensum]

	@idPensum int
AS
BEGIN

	SET NOCOUNT ON;
	UPDATE Pensum
	SET statusPensum = 'DESACTIVADO', fechaFin = GETDATE()
	WHERE id_Pensum = @idPensum;
END